﻿<%@ Page Language="vb" AutoEventWireup="false" MasterPageFile="~/Banner.Master" CodeBehind="MaterialsByTag.aspx.vb" Inherits="ETeacherforIELTS.MaterialsByTag" 
    title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <link href="style.css" rel="stylesheet" type="text/css" />
       
   
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <table class="bgStyle">
        <tr>
            <td class="sides">
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td class="sides">
                &nbsp;</td>
        </tr>
        <tr>
            <td >
                </td>
            <td >
                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                    DataSourceID="SqlDataSource1">
                    <Columns>
                        <asp:HyperLinkField DataNavigateUrlFields="TagName" 
                            DataNavigateUrlFormatString="MaterialsByTag.aspx?Tag={0}" 
                            DataTextField="TagName" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
                    SelectCommand="SELECT [TagName] FROM [Tags]"></asp:SqlDataSource>
            </td>
            <td >
                <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                    DataSourceID="SqlDataSource2">
                    <Columns>
                        <asp:BoundField DataField="MaterialName" HeaderText="MaterialName" 
                            SortExpression="MaterialName" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
                    SelectCommand="SELECT [TagName], [MaterialName] FROM [TagsMaterialQuery] WHERE ([TagName] = ?)">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="TagName" QueryStringField="Tag" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td >
                </td>
        </tr>
        <tr>
            <td >
            </td>
            <td >
            </td>
            <td >
            </td>
            <td >
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>
